package com.itheima.motorcycletype.dao;

import com.itheima.motorcycletype.pojo.Logo;
import com.itheima.motorcycletype.pojo.MotorcycleType;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.entity.Example;

import java.util.List;
import java.util.Map;

public interface MotorcycleTypeMapper extends Mapper<MotorcycleType> {
    @Select("SELECT * FROM tb_logo WHERE id IN(SELECT logo_id FROM tb_motorcycletype WHERE NAME=#{name} AND CODE=#{code})")
    List<Logo> selectByMotorcycleType(Example example);
}
